<!--

    Copyright (c) 2005, 2018 Oracle and/or its affiliates. All rights reserved.
    Portions Copyright &#169; [2017-2020] Payara Foundation and/or affiliates.

    This program and the accompanying materials are made available under the
    terms of the Eclipse Public License v. 2.0, which is available at
    http://www.eclipse.org/legal/epl-2.0.

    This Source Code may also be made available under the following Secondary
    Licenses when the conditions for such availability set forth in the
    Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
    version 2 with the GNU Classpath Exception, which is available at
    https://www.gnu.org/software/classpath/license.html.

    SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0

-->
<!-- Portions Copyright [2019] [Payara Foundation and/or its affiliates] -->

<p><a id="ref-jdbcconnectionpools" name="ref-jdbcconnectionpools"></a><a id="GHJDB00023" name="GHJDB00023"></a></p>

<h4><a id="sthref38" name="sthref38"></a>Connection Pools</h4>
<a name="BEGIN" id="BEGIN"></a>
<p>A JDBC connection pool contains a group of JDBC connections that are created when the connection pool is registered. Connection pools use a JDBC driver to create physical database connections. Your application borrows a connection from the pool, uses it, then returns it to the pool by closing it. To create a JDBC resource, specify the associated connection pool. Multiple JDBC resources can specify a single connection pool.</p>
<p>A JDBC connection pool is a group of reusable connections for a particular database. Because creating each new physical connection is time-consuming, the server maintains a pool of available connections to increase performance. When an application requests a connection, it obtains one from the pool. When an application closes a connection, the connection is returned to the pool.</p>
<p>When creating a connection pool with the Administration Console, you are defining the aspects of a connection to a specific database.</p>
<p>Use the JDBC Connection Pools page to configure JDBC connection pools.</p>
<p>For each connection pool, the following information is provided.</p>
<dl>
<dt>Pool Name</dt>
<dd>
<p>The name of the connection pool.</p>
</dd>
<dt>Resource Type</dt>
<dd>
<p>The resource type of the connection pool.</p>
</dd>
<dt>Classname</dt>
<dd>
<p>The name of the vendor-specific class that implements the <code>javax.sql.XADataSource</code>, <code>java.sql.ConnectionPoolDataSource</code>, <code>javax.sql.DataSource</code>, or <code>java.sql.Driver</code> API.</p>
</dd>
<dt>Description</dt>
<dd>
<p>A short description of the connection pool.</p>
</dd>
</dl>
<p>The Pools table also contains the following options.</p>
<dl>
<dt>New</dt>
<dd>
<p>Button to create a new connection pool.</p>
</dd>
<dt>Delete</dt>
<dd>
<p>Button to delete one or more selected connection pools.</p>
</dd>
</dl>
<a id="sthref39" name="sthref39"></a>
<h5>Related Tasks</h5>
<ul>
<li>
<p><a href="task-setdbaccess.html">To Set Up Database Access</a></p>
</li>
<li>
<p><a href="task-integratejdbcdriver.html">To Integrate a JDBC Driver</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpoolnew.html">To Create a JDBC Connection Pool</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooledit.html">To Edit JDBC Connection Pool General Settings</a></p>
</li>
<li>
<p><a href="task-verifyconnpoolsettings.html">To Verify Connection Pool Settings</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooladvance.html">To Edit JDBC Connection Pool Advanced Attributes</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpoolproperty.html">To Edit JDBC Connection Pool Properties</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooldelete.html">To Delete a JDBC Connection Pool</a></p>
</li>
</ul>
<a id="sthref40" name="sthref40"></a>
<h5>Related asadmin Commands</h5>
<ul>
<li>
<p><a href="/resource/reference/en/help/reference/add-resources"><code>add-resources</code>(1)</a></p>
</li>
<li>
<p><a href="/resource/reference/en/help/reference/create-jdbc-connection-pool"><code>create-jdbc-connection-pool</code>(1)</a></p>
</li>
<li>
<p><a href="/resource/reference/en/help/reference/delete-jdbc-connection-pool"><code>delete-jdbc-connection-pool</code>(1)</a></p>
</li>
<li>
<p><a href="/resource/reference/en/help/reference/flush-connection-pool"><code>flush-connection-pool</code>(1)</a></p>
</li>
<li>
<p><a href="/resource/reference/en/help/reference/list-jdbc-connection-pools"><code>list-jdbc-connection-pools</code>(1)</a></p>
</li>
<li>
<p><a href="/resource/reference/en/help/reference/ping-connection-pool"><code>ping-connection-pool</code>(1)</a></p>
</li>
<li>
<p><a href="/resource/reference/en/help/reference/start-database"><code>start-database</code>(1)</a></p>
</li>
<li>
<p><a href="/resource/reference/en/help/reference/stop-database"><code>stop-database</code>(1)</a></p>
</li>
</ul>


<small>Copyright &#169; 2005, 2017, Oracle and/or its affiliates. All rights reserved. <a href="docinfo.html">Legal Notices</a></small>
<small>Portions Copyright &#169; [2017-2020] Payara Foundation and/or affiliates.</small>
